package net.bwie.realtime.jtp.jtprealtimepub.mapper;

import net.bwie.realtime.jtp.jtprealtimepub.bean.TraffiChannelUvBean;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;

public interface TrafficChannelStartMapper {



    @Select("select\n" +
            "    channel,\n" +
            "    sum(uv_count) as  uv_count\n" +
            "    from jtp_log_report.dws_log_page_view_window_report\n" +
            "where toDate(window_start_time)=#{date}\n" +
            "group by channel")
    List<TraffiChannelUvBean> selectUvCount(@Param("date") String date);
}
